Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_TIMESTAMP_TZ_FORMAT

Property | Description
--- | ---
Parameter type | String
Syntax | `NLS_TIMESTAMP_TZ_FORMAT = "``format``"`
Default value | Derived from `NLS_TERRITORY`
Modifiable | `ALTER SESSION`
Range of values | Any valid datetime format mask

`NLS_TIMESTAMP_TZ_FORMAT` defines the default timestamp with time zone format to use with the `TO_CHAR` and `TO_TIMESTAMP_TZ`functions.

The value must be surrounded by quotation marks as follows:

    NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF TZH:TZM'

You can specify the value of `NLS_TIMESTAMP_TZ_FORMAT` by setting it in the initialization parameter file. You can specify its value for a client as a client environment variable.

You can also alter the value of `NLS_TIMESTAMP_TZ_FORMAT` by changing its value in the initialization parameter and then restarting the instance. To alter the value during a session use the `ALTER SESSION SET` statement.